USE DeltaFlex
GO
IF(OBJECT_ID('dbo.sp_CercarConcepte_OTByIdOrdre')IS NOT NULL)
	DROP PROCEDURE dbo.sp_CercarConcepte_OTByIdOrdre
GO

CREATE PROCEDURE dbo.sp_CercarConcepte_OTByIdOrdre
	@IDORDRE int
AS 
BEGIN
SELECT *
  FROM CONCEPTE_OT C
  INNER JOIN ARTICLES A
		  ON A.IDARTICLE = C.IDARTICLE
       WHERE IDORDRE = @IDORDRE
END 
GO